﻿CREATE TABLE [dbo].[Finance_Profit_Regulate] (
    [Id]               INT             IDENTITY (1, 1) NOT NULL,
    [Mid]              INT             NULL,
    [CompanyId]        INT             NULL,
    [CompanyName]      NVARCHAR (200)  NULL,
    [Summary]          VARCHAR (500)   NULL,
    [Amount]           DECIMAL (18, 2) NULL,
    [FillOutUserId]    VARCHAR (50)    NULL,
    [FillOutUserName]  VARCHAR (50)    NULL,
    [RegulateDate]     DATETIME        NULL,
    [FillOutDate]      DATETIME        NULL,
    [Deleted]          BIT             CONSTRAINT [DF__Finance_P__Delet__07C38B35_Moebius] DEFAULT ((0)) NULL,
    [Approval]         INT             CONSTRAINT [DF_Finance_Profit_Regulate_Approval] DEFAULT ((0)) NOT NULL,
    [ApprovalComments] VARCHAR (500)   NULL,
    [ApprovalUserId]   VARCHAR (50)    NULL,
    [ApprovalName]     VARCHAR (50)    NULL,
    [ApprovalTime]     DATETIME        CONSTRAINT [DF_Finance_Profit_Regulate_ApprovalTime] DEFAULT ('1900-01-01') NOT NULL,
    CONSTRAINT [PK_FINANCE_PROFIT_REGULATE] PRIMARY KEY CLUSTERED ([Id] ASC)
);


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = '实收纯利调整', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Finance_Profit_Regulate';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = '管理区', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Finance_Profit_Regulate', @level2type = N'COLUMN', @level2name = N'Mid';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = '公司ID', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Finance_Profit_Regulate', @level2type = N'COLUMN', @level2name = N'CompanyId';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = '公司名称', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Finance_Profit_Regulate', @level2type = N'COLUMN', @level2name = N'CompanyName';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = '摘要', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Finance_Profit_Regulate', @level2type = N'COLUMN', @level2name = N'Summary';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = '金额', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Finance_Profit_Regulate', @level2type = N'COLUMN', @level2name = N'Amount';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = '填写人ID', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Finance_Profit_Regulate', @level2type = N'COLUMN', @level2name = N'FillOutUserId';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = '填写人名称', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Finance_Profit_Regulate', @level2type = N'COLUMN', @level2name = N'FillOutUserName';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = '调整日期', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Finance_Profit_Regulate', @level2type = N'COLUMN', @level2name = N'RegulateDate';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = '填写日期', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Finance_Profit_Regulate', @level2type = N'COLUMN', @level2name = N'FillOutDate';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = '是否删除', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Finance_Profit_Regulate', @level2type = N'COLUMN', @level2name = N'Deleted';

